SUPPORT / SAMPLES & SAS NOTES
Problem Note 59426: Viewing data from SAS® Federation Server Manager 4.2 returns the error “The data cannot be shown..."
 |  |  |  |  |
When viewing data in SAS Federation Server Manager 4.2, you might receive the following error:
The data cannot be shown because either the source does not exist or it cannot be accessed.
This error occurs if large row-level security has been applied.
For example, a particular user is required to be a part of 17 groups. Row-level security has been applied on these 17 groups in SAS Federation Server, and these groups are the various sources from which data is being extracted. When you try to view the data, the SAS Federation Server log with tracing shows the following error:
ERROR [00005441] Audit.Table.Security.Provider...SELECT privilege RLS predicate truncated. Privilege will be denied.
A workaround is to ensure that users are not associated with more than 10 groups.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Federation Server | Linux for x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M4 |
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft® Windows® for x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||